﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_FIT_WEIGHT_TRAINING_Update')
	BEGIN
		DROP Procedure usp_UPDMS_FIT_WEIGHT_TRAINING_Update
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_FIT_WEIGHT_TRAINING_Update
**	Desc : 운동수행관리를 수정한다.
**	Test Exec Query : Exec usp_UPDMS_FIT_WEIGHT_TRAINING_Update
**	Called by : Fit_Dac_UPDMS_FIT_WEIGHT_TRAINING.cs
**	Program ID : Fit1011m
**	Auth : 송시명
**	Date : 2014-05-21
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_FIT_WEIGHT_TRAINING_Update]
@Seq int,
@Training_Id nvarchar(10),
@Training_Dt nvarchar(10),
@Start_Hour nvarchar(2),
@Start_Minute nvarchar(2),
@End_Hour nvarchar(2),
@End_Minute nvarchar(2),
@Location nvarchar(100),
@Create_User nvarchar(20),
@Create_Dt datetime,
@Update_User nvarchar(20),
@Update_Dt datetime
AS
SET NOCOUNT OFF

UPDATE UPDMS_FIT_WEIGHT_TRAINING
   SET Training_Id = @Training_Id,
       Training_Dt = @Training_Dt,
       Start_Hour = @Start_Hour,
       Start_Minute = @Start_Minute,
       End_Hour = @End_Hour,
       End_Minute = @End_Minute,
       Location = @Location,
       Update_User = @Update_User,
       Update_Dt = GETDATE()
 WHERE Seq = @Seq

GO